create external table jms_ods.`spot_check_task_detail` (
  `spot_check_task_detail_id` bigint,
  `regional_name` string  comment '大区名称',
  `network_name` string  comment '网点名称',
  `network_code` string  comment '网点编码',
  `random_number` string  comment '抽查单号',
  `task_type` string  comment '任务名称(类型)',
  `agent_areas_name` string  comment '抽查代理区名称(多个用,拼接)',
  `user_name` string  comment '员工姓名',
  `user_code` string  comment '员工编码',
  `create_user` string  comment '发布人',
  `start_time` datetime  comment '下发时间',
  `end_time` datetime  comment '截止时间',
  `task_status` string  comment '任务状态(未完成(unfinished),已完成(finished))',
  `review_status` string  comment '审核状态(待审核(wait),已通过(success),未通过(fail))',
  `auditor_name` string  comment '审核人',
  `create_time` datetime  comment '创建时间',
  `update_time` datetime  comment '更新时间',
  `picture_url` string  comment '附件详情',
  `regional_id` string  comment '大区编码',
  `agent_areas_code` string  comment '抽查代理区编码(多个用,拼接)',
  `login_user_id` bigint  comment '用户id',
  `issuer` string  comment '发布人',
  `create_user_code` string  comment '创建人编码',
  `auditor_code` string  comment '审核人编码',
  `complete_time` datetime  comment '完成时间',
  `audit_time` datetime  comment '审核时间',
  `remark` string  comment '备注'
)comment  '抽查任务详情'
    PARTITIONED BY (dt STRING COMMENT '更新日期 (yyyy-MM-dd)')
    STORED AS PARQUET
    LOCATION '/dw/hive/jms_ods.db/external/spot_check_task_detail'
    TBLPROPERTIES (
        'discover.partitions' = 'false',
        'parquet.column.index.access' = 'true'
        );
